-- @owner: z@wan005
-- @date: 2023/5/18
-- @testpoint: uncompress函数作为关键字测试
--step1:查询系统表;expect:不是关键字
select * from pg_get_keywords() where word ='uncompress';
--step2:作为数据库名;expect:成功
drop database if exists uncompress;
create database uncompress dbcompatibility 'B';
drop database if exists uncompress;
--step3:作为列名和表名;expect:成功
drop table if exists uncompress;
create table uncompress(uncompress timestamp);
drop table uncompress;
--step4:作为外部数据源名;expect:成功
drop data source if exists uncompress;
create data source uncompress;
drop data source if exists uncompress;
--step5:作为自定义函数名;expect:成功
drop function if exists uncompress(i integer);
create function uncompress(i integer)
returns integer
as $$
begin
    return i+1;
end;
$$ language plpgsql;
/
drop function if exists uncompress(i integer);
--step6:作为用户名;expect:成功
drop user if exists uncompress;
create user uncompress password 'Test_123';
drop user if exists uncompress;